create table jms_dwd.dwd_YL_OMS_ORDER_TRANSFER_DT
(
  ID                         bigint                    comment  '订单ID'
  ,WAYBILL_ID                string                    comment  '运单号'
  ,TERMINAL_DISPATCH_CODE     string                   comment  '三段码'
  ,DISPATCH_NETWORK_CODE     string                    comment  '派件网点编码'
  ,DISPATCH_NETWORK_NAME     string                    comment  '派件网点名称'
  ,LAST_CENTER_CODE          string                    comment  '集包地编码'
  ,LAST_CENTER_NAME           string                   comment  '集包地名称'
  ,INPUT_TIME                 date                    comment  '订单录入时间'
  ,CREATE_TIME                date                     comment  '创建时间'
  ,NEW_TERMINAL_DISPATCH_CODE string
)
COMMENT '转寄件原单信息'
PARTITIONED BY (
  `dt` string COMMENT '分区(yyyy-mm-dd)')
STORED AS PARQUET
LOCATION
  '/dw/hive/jms_dwd.db/external/dwd_YL_OMS_ORDER_TRANSFER_dt';
